Data Type Matching
The table below shows the data type matching between PostgreSQL and an OpenCities Map XFM schema.
For more information on PostgreSQL native data types, please refer to https://www.postgresql.org.
| Name | Aliases | Description | XFM Type |
|---|---|---|---|
| bigint | int8 | signed eight-byte integer | Integer |
| bigserial | serial8 | autoincrementing eight-byte integer | Integer |
| bit [ (n) ] | fixed-length bit string | Not Modeled | |
| bit varying [ (n) ] | varbit [ (n) ] | variable-length bit string | Not Modeled |
| boolean | bool | logical Boolean (true/false) | Not Modeled |
| box | rectangular box on a plane | Not Modeled | |
| bytea | binary data ("byte array") | Not Modeled | |
| character [ (n) ] | char [ (n) ] | fixed-length character string | Not Modeled |
| character varying [ (n) ] | varchar [ (n) ] | variable-length character string | String |
| cidr | IPv4 or IPv6 network address | Not Modeled | |
| circle | circle on a plane | Not Modeled | |
| date | calendar date (year, month, day) | Dateticks | |
| double precision | float8 | double precision floating-point number (8 bytes) | Double |
| inet | IPv4 or IPv6 host address | Not Modeled | |
| integer | int, int4 | signed four-byte integer | Integer |
| interval [ fields ] [ (p) ] | time span | Not Modeled | |
| json | textual JSON data | Not Modeled | |
| jsonb | binary JSON data, decomposed | Not Modeled | |
| line | infinite line on a plane | Not Modeled | |
| lseg | line segment on a plane | Not Modeled | |
| macaddr | MAC (Media Access Control) address | Not Modeled | |
| money | currency amount | Integer | |
| numeric [ (p, s) ] | decimal [ (p, s) ] | exact numeric of selectable precision | Not Modeled |
| path | geometric path on a plane | Not Modeled | |
| pg_lsn | PostgreSQL Log Sequence Number | Not Modeled | |
| point | geometric point on a plane | Not Modeled | |
| polygon | closed geometric path on a plane | Not Modeled | |
| real | float4 | single precision floating-point number (4 bytes) | Double |
| smallint | int2 | signed two-byte integer | Integer |
| smallserial | serial2 | autoincrementing two-byte integer | Integer |
| serial | serial4 | autoincrementing four-byte integer | Not Modeled |
| text | variable-length character string | String | |
| time [ (p) ] [ without time zone ] | time of day (no time zone) | Dateticks | |
| time [ (p) ] with time zone | timetz | time of day, including time zone | Dateticks |
| timestamp [ (p) ] [ without time zone ] | date and time (no time zone) | Dateticks | |
| timestamp [ (p) ] with time zone | timestamptz | date and time, including time zone | Dateticks |
| tsquery | text search query | Not Modeled | |
| tsvector | text search document | Not Modeled | |
| txid_snapshot | user-level transaction ID snapshot | Not Modeled | |
| uuid | universally unique identifier | String | |
| xml | XML data | Not Modeled |